﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using QLTH_DTO;
namespace QLTH_DATASSECC
{
   public class clsKhoiDA : ConnectionData.clsKetNoi
    {
       String _sql;
       public DataTable DanhSachKhoi()
       {
           _sql = "SELECT MAKHOI,TENKHOI FROM KHOI";
           return Load_DataTable(_sql);
       }

       public string Laymakhoi(String _dk)
       {
           _sql = "SELECT MAKHOI FROM KHOI WHERE TENKHOI = N'" + _dk + "'";
           return laymadk(_sql).ToString();
       }
    }
}
